Live freelance tracking. Raw descriptions turned into structured data. Find your next tech project without the noise.
upwork.com 🟢 2026-05-28
🔹 NetSuite to Power BI Data Architecture Stabilization
👤 Client: 🇮🇪 Ireland Member since 2019-10-06
💰 Price: ****
🚩 Problem: Mature but organically grown reporting estate with fragile extraction methods and undocumented logic requiring stabilization and scalable target architecture.
📦 Existing: Power BI reports/PBIX files, NetSuite data, Tactical Connect saved-search exports, SharePoint-hosted sources, IQY extracts, SFTP-derived data.
Specifications:
[Target] NetSuite ERP
[Target] Power BI Semantic Model
[Method] SuiteAnalytics Connect
[Method] SuiteQL
[Method] SuiteTalk / RESTlets
[Method] ODBC/JDBC
[Method] Power Query / M
[Method] DAX
[Stack] Azure SQL Staging Layer
[Stack] Microsoft Fabric
[Format] Star Schema (Facts/Dimensions)
[Format] Data Source Map
[Format] Risk Map
Workflow:
1. Audit existing PBIX files and reverse-engineer complex business logic.
2. Map data sources and identify architectural risks/duplicates.
3. Stabilize Credit Control reporting by replacing IQY/personal gateway flows.
4. Design target architecture for extraction, staging, and governance.
5. Validate Power BI outputs against NetSuite source data.